SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491275 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491275 [ RunTime:0.002172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439260,194110,16731,668367,911279,1014550,1018749,197543,530196,54654,20702,552560,856624,357235,140487,938729,486673,260702,44833,107505,175279,858229,613053,270110,425526,140796,370330,336900,948351,236260,439331,746480,273903,825708,882077,209493,703747,356951,800836,426195,698488,796900,926703,271374,784738,183509,625146,145430,133980,594402,818869,144434,618714,1047265,812247,756149,758582,895018,145793,695614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491275 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491275 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]