SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001762s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101979 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101979 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19279,485160,315533,183824,954864,361893,565749,886438,918894,240315,210197,674043,272890,506983,720371,503042,197397,46524,829842,847654,428188,265469,103223,791979,714267,292876,399198,85918,32284,331701,245745,29106,902395,944496,454648,440277,87738,149039,125766,33566,580618,958631,420739,736517,285455,770022,50656,717817,972353,790108,972811,416638,20170,870451,132132,110240,857884,424238,245521,768695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101979 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101979 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]