SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040471 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040471 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281182,646325,27962,657812,696430,671185,201663,1009841,732287,484253,103168,821270,402772,719757,844786,366695,425151,411444,13508,495395,724520,274553,802654,993783,42751,208604,88565,832584,236384,242375,795816,905560,584035,321282,751155,144831,909769,390929,463356,614069,520143,847957,174227,280277,629605,242020,668318,170596,605050,843141,925214,458725,604253,331411,105225,971754,173673,319825,782809,233254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]