SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 379513 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 379513 [ RunTime:0.002133s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022586,602342,1014397,869599,399476,321576,790823,823500,312007,236396,718036,924927,69235,555085,361687,743121,939807,817032,942815,203424,633863,157662,14607,620600,89341,93096,587445,231699,685806,75272,130456,811610,600212,925747,981645,503799,127060,1025548,93190,80454,635460,168920,494771,24159,58473,746483,940755,54935,364932,522502,1041086,694855,673937,320671,779875,927795,424807,583162,954983,770335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 379513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 379513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001339s ]