SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 374938 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 374938 [ RunTime:0.002192s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685671,77828,541030,875545,1038171,901715,624449,988641,813073,748310,953010,105021,492701,698309,910528,181347,265735,498087,807380,122945,171747,245932,789982,180299,653363,190716,497194,274795,33997,320101,682186,575314,860703,110700,622216,572980,917387,449882,519327,505461,814457,334495,29779,16328,728190,283667,118909,759161,1042482,178402,584922,447732,135280,529780,412365,296446,474173,743526,386621,638315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 374938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 374938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]