SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 6816 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 6816 [ RunTime:0.003000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702189,488036,334615,279031,69885,165431,457893,585677,632218,440394,207362,752452,171690,709449,120436,167393,212652,502131,753579,211571,394035,639286,901324,885707,244496,685951,585508,1008665,486112,726223,467336,120824,410120,804912,673674,730396,488683,803465,806746,1006208,641844,553591,439963,73737,897999,567059,1028105,622595,918820,677747,334835,995480,780325,70735,645857,468887,848680,627655,426473,347112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 6816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 6816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]