SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383410 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383410 [ RunTime:0.002664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022086,288460,519615,868167,935418,47340,351112,217573,756329,884758,256916,70800,41797,854547,413336,65756,254221,103547,329418,865600,363799,388596,841852,479677,50490,562585,200380,905092,569454,1008368,32090,353684,396979,226619,6452,787042,535060,858753,916947,820244,460049,506416,410346,83534,121049,181505,645826,641530,127434,226879,92351,426074,868839,1020402,257697,849329,178371,876164,491640,600310) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]