SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415069 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415069 [ RunTime:0.002351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559391,547734,35574,197105,796339,592292,669713,206889,1008159,970395,17924,291019,614453,750960,775832,253027,962587,1002991,822213,923835,353681,279753,576235,482154,923514,740476,820778,229973,919991,19521,994746,832415,141783,738356,359379,316605,691851,179977,936998,124873,135323,413306,432669,733894,751783,864564,796523,413851,906234,247836,155645,404356,334784,519092,424315,614215,79323,786283,647829,299588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415069 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415069 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000758s ]