SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553711 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553711 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808351,932578,169642,9613,475847,446317,438206,918033,313220,628393,867176,698854,536317,337621,794767,1026430,938040,762112,907003,252337,204364,974082,564854,134994,104502,759745,779096,431042,239752,562290,684581,39567,756772,519492,232016,464864,806782,1016581,680260,404502,441634,458362,99594,87342,793774,871698,393469,561545,558797,982450,881901,822342,373737,379629,787672,893481,301953,194708,940821,1038720) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003120s ]