SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004886 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004886 [ RunTime:0.001460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24139,773035,211114,488363,113758,4194,355909,701120,359668,781047,491767,993015,341092,439351,961713,564841,1043381,400569,425587,127368,880877,740466,335371,1038908,802610,299185,722070,283368,615704,879196,913362,707403,73856,259760,133102,922728,2437,742665,946751,673127,321983,912523,370566,604056,224202,294988,843972,162596,917056,25389,727043,557045,191677,745411,318647,12634,590095,412061,126025,753258) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004886 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004886 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000939s ]