SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524842 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524842 [ RunTime:0.002447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17819,424698,47817,14680,286972,869136,381225,538618,439579,565349,919617,532365,604394,944452,311374,501566,665269,739209,924601,243490,469643,460842,108435,8386,401828,593910,787304,699821,505633,616951,1030479,603616,567905,483852,657283,461666,1037424,160415,667258,134654,854114,883915,968936,634310,90388,330865,886186,265414,461427,1046334,744542,92350,523552,486869,209733,306606,508552,183638,527104,868835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]