SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541130 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541130 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865819,8858,938826,974225,761404,82479,760510,951194,455928,902186,180644,77392,179527,808746,875016,766551,587780,510124,967672,242347,161229,75136,1010846,833220,498401,274482,34055,289877,233614,998708,833726,51707,1010626,760334,285993,1044666,559105,956852,1041811,153772,812362,838769,958052,264728,325987,900299,203363,314781,947246,364341,451453,929138,960450,369243,13146,629644,592400,436634,862651,732261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541130 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541130 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002251s ]