SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980417 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980417 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392634,666673,96253,281881,408528,484751,486027,751135,683287,350125,994774,639946,947025,507355,75970,1016093,762663,170801,289843,519825,172633,107073,853386,779140,343307,1013060,456523,490769,764925,228322,888920,130138,925698,158869,1040131,563432,250056,138500,564811,539518,339300,239379,378962,904829,557543,196174,423480,158966,640303,153658,1039275,533522,293632,789174,730489,910126,469363,246556,340956,504766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]