SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412029 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412029 [ RunTime:0.003777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726860,804952,988415,489640,594701,786281,632077,394285,358632,471551,672703,180045,526261,618961,598045,245823,38120,134905,73268,1027667,471661,715969,483615,703086,878979,922801,61535,100434,517078,162730,1006398,103684,6718,139774,106181,817416,490914,590891,980572,487147,189534,427379,957708,964551,194670,780570,399210,314484,1397,146846,765630,71090,309898,820167,911491,480184,379836,427773,922593,126971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]