SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027548 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027548 [ RunTime:0.002583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124497,252553,85905,149122,744177,613952,508798,114575,361500,309369,497938,522586,505686,329122,787875,891015,85327,178356,768571,232028,22867,1030975,582427,563153,1003849,40956,1045173,708943,1012050,351592,965422,890274,292487,562070,926660,1020373,116451,253672,495572,902650,367530,649898,143187,308021,351043,72500,204956,403739,37264,158865,946138,155594,820002,578068,985032,725852,809177,730475,366561,662662) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027548 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027548 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002349s ]