SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405944 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405944 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (233285,956348,713549,916798,872925,762112,701984,761080,862606,344647,877398,339302,737555,343518,69950,101727,502095,680158,578505,389917,585033,498556,291513,241565,672930,445946,182488,845075,888784,397460,104667,559599,272507,682226,505553,547715,633090,993111,33408,85674,955116,672090,433549,568139,135738,136903,823595,991893,775649,724674,163962,57594,414903,148414,415879,575615,953900,661219,938348,752595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002552s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002665s ]