SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422172 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422172 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1043551,1005901,1045732,889252,662654,10141,778749,59781,152881,679165,800679,140086,806141,428159,759891,627197,959464,69668,129330,696387,902993,887799,987538,726510,590566,694691,84360,667927,526674,836917,323825,98871,997971,921159,731445,840267,861630,29136,199820,318097,999458,812321,228713,281328,806071,274386,807231,63548,64929,598381,387473,1036294,385097,560523,1008815,164619,920394,875398,79251,593594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422172 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422172 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]