SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10844 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10844 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20779,1039542,800214,50900,330198,259123,429680,694155,916417,548145,606008,320725,197882,417346,549898,690447,74244,678145,228138,843034,371833,617343,377435,1037520,377293,206887,331836,664973,834555,805600,538066,206269,455878,278308,520930,916205,396103,389685,799109,706352,1046464,755559,412129,412400,168543,420113,119263,33598,589306,672997,692527,982864,349867,790862,318775,433812,576202,128786,911847,977324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]