SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443001 LIMIT 1 [ RunTime:0.000603s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443001 [ RunTime:0.002388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83324,886736,694982,510961,106498,104711,929100,94205,827650,703970,883425,68114,1001576,920839,274935,99658,528343,798888,478248,64071,90366,176443,92604,216805,1012344,96070,967936,4925,396200,763861,604085,731392,730330,493897,269502,45040,404537,175678,912411,1046149,117707,618912,300562,10082,895650,717705,312453,433167,460239,853061,991266,229167,1036295,734008,707259,646883,380371,222580,126856,21223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]