SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59180 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59180 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441462,489558,554700,402574,414641,182908,589132,385653,863490,363245,845946,784161,986513,143159,22805,340596,1008675,1009251,556430,430039,136850,764843,314170,1032005,254673,454440,65555,1039890,18243,85360,516402,54686,409450,30425,109593,148312,213203,312716,151906,41400,248100,89027,692002,342180,916683,687007,120169,240216,375380,665920,954355,579,365935,538570,1014315,808593,455160,820144,815545,80573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]