SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 652007 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 652007 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (772283,1015980,701166,817065,361280,25207,834859,376126,703156,636677,11948,528190,408984,351829,399981,296236,241590,261875,979497,522196,651740,368195,71348,1030344,283017,817928,764869,262663,779869,435689,62915,103746,1018104,441873,148008,15223,393776,999802,500320,231199,123027,939518,626338,778905,322900,863596,1017823,169762,465522,180557,119145,447111,987788,463066,904778,982249,87768,80694,221134,17022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 652007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 652007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002867s ]