SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010186 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010186 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47714,665881,257394,52909,442006,977205,657876,489232,405939,68870,391195,979878,978420,644303,410280,598122,786734,677987,779483,822586,822650,144036,610714,999162,301645,146900,29325,663104,637879,825757,362962,588879,854656,31743,891653,840685,277858,420940,1021015,993307,412620,878640,494202,314933,8355,809291,888842,26269,667035,900116,732553,788089,260112,76021,1024852,325237,786666,23141,164299,105061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]