SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 704817 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 704817 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1024393,119132,274425,747821,240996,393147,573397,313651,93002,167142,293055,121733,1002786,994773,985547,8916,958444,504202,706383,583801,377608,292630,608717,230731,277860,570155,705626,394755,31033,255316,489323,411062,457099,201879,833544,1022652,43419,765324,620471,133280,316387,211756,705575,1039508,1000042,986544,16525,922529,163962,273304,885587,503045,838028,571837,462571,286875,644821,195564,533229,1010859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 704817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 704817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]