SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38650 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38650 [ RunTime:0.004210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384608,349232,524713,896885,311499,593021,657362,323867,78978,712890,391532,242843,820651,989514,733807,784116,549641,558989,843966,264521,300216,354264,655743,160403,579985,693746,255334,428171,477737,539458,701459,683593,180998,346717,32872,627404,817305,273109,793453,487448,440322,399233,1016437,324994,262567,919268,940086,811821,273509,200086,476629,89132,886574,772460,687969,247143,196558,996835,372232,1002518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]