SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 841983 LIMIT 1 [ RunTime:0.000836s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 841983 [ RunTime:0.002499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806650,230601,36331,333610,426593,503856,693140,701524,773942,878645,250209,483040,72904,541649,524320,721469,387216,927712,959015,448633,149862,819639,258918,931352,550629,782860,976923,820973,436201,124437,909023,436048,99295,742604,375069,576479,488761,315661,899423,983445,65611,41091,267854,906413,792510,418418,853902,747204,169130,442912,599459,342600,272552,129828,311061,670913,212922,520193,596667,1048452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 841983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 841983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]