SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 384801 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 384801 [ RunTime:0.002289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (887070,994310,10818,170881,138762,276555,673354,11032,319970,986539,158106,655130,388078,321341,273826,550713,591555,725226,284806,446615,209924,826851,376399,338630,262031,435342,147520,425801,149650,568276,926006,826674,796580,271810,751451,718759,115562,290158,859010,957817,890176,714747,170197,578318,875287,640066,817512,765543,1044713,331362,912445,332730,545168,998401,660251,438068,910930,15085,728981,648891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 384801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 384801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]