SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001756s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506432 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506432 [ RunTime:0.006936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107600,912879,985505,393111,730589,68921,666779,271915,963611,559193,803490,321041,398742,247548,978202,241368,446682,162307,30081,810827,577277,94880,229671,400955,181940,574071,179278,28834,465251,542424,351921,535779,527497,376085,619004,523144,20354,558310,561155,36288,616340,781342,253494,45642,67070,703473,781024,221153,58041,274345,1032808,128571,952577,1011206,940171,944702,919265,196848,869701,793676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506432 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001894s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506432 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001196s ]