SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005821s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425805 LIMIT 1 [ RunTime:0.000623s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425805 [ RunTime:0.003066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573491,104916,272650,163736,691198,388393,194963,1034937,861915,963994,673736,808082,720182,772239,747055,424540,828850,911329,615044,969730,922030,691984,484015,476377,207475,909147,194833,964908,1001571,36924,785552,945044,733743,712243,171913,913538,70661,200259,648930,126481,631826,318925,468995,768212,391807,65386,331858,810059,780238,332469,20998,190428,513124,1003389,548270,115917,1033307,830989,688734,759329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]