SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497014 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497014 [ RunTime:0.006348s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044593,361586,453952,427525,1023174,668528,660921,271443,420218,881651,766782,99930,324583,613123,564821,175311,48299,174253,929686,335245,670742,755068,449857,484212,678866,826297,217190,555461,955999,836756,658435,336333,231029,1000188,798538,1022364,932424,405532,405117,466118,377797,105639,253793,433269,1038068,680630,525417,316026,722159,220806,472261,365662,120094,922930,806596,683307,982211,724768,429980,258193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001187s ]