SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040017 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040017 [ RunTime:0.002141s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464140,495381,500004,906113,967683,21567,540923,519061,295537,45715,19221,321590,165069,755339,987933,976196,528207,963306,682333,670809,720132,464437,196045,222001,607471,264897,280906,228116,909536,915714,678372,109638,81880,308778,13679,343288,446095,441560,442443,603616,465680,157109,305741,498067,570239,808075,206565,689269,751568,430306,941651,58610,1013789,12416,92716,411825,795143,970276,682600,228679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006776s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001632s ]