SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803993 LIMIT 1 [ RunTime:0.000755s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803993 [ RunTime:0.003871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196437,195082,65920,691436,389426,93995,597454,492805,203488,394645,343041,900434,499362,1033403,451177,199657,504607,616544,302405,772360,417907,128671,631963,453525,490374,656337,732685,470086,982357,551360,387732,68430,889004,426257,870567,617026,571279,727920,752620,313940,604157,189515,104626,422643,820789,882661,969485,213672,777796,552356,513282,1036634,1010136,58083,963944,1011020,864821,218413,396345,507853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000801s ]