SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003709s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457765 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457765 [ RunTime:0.005385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306067,866828,479164,600234,930844,143147,699647,109808,70973,355029,256989,52332,583063,245867,556363,206062,267451,598864,69383,304450,136609,875989,647504,28161,581589,670864,201529,1015693,594173,905713,1019247,789310,437559,254630,590084,843901,984975,708595,656179,867236,733056,979345,63108,548070,957250,537752,288622,198875,517629,124547,861441,276578,526635,1029785,323873,107988,1001272,557476,707486,946211) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]