SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012420 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012420 [ RunTime:0.006358s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601962,91735,595541,988469,461525,169998,207646,419149,374732,861427,375262,619158,282708,324983,723524,178007,840960,572381,161127,361910,10022,869297,591337,432867,895750,421237,1034975,962196,536534,869203,993672,121976,513817,786541,466693,450303,121085,949694,605985,953796,1009762,314845,235514,629197,303537,855484,169902,461054,289898,828747,804017,564263,403743,696793,424508,843732,349456,1040688,28709,399708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.008544s ]