SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466259 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466259 [ RunTime:0.002188s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411225,101519,807786,646480,210789,574594,871514,138856,208781,109281,210775,633961,863811,711821,627955,15764,268959,84911,254504,374050,705385,498722,1005332,1026249,924215,575696,141442,284007,554926,141954,1043860,949564,324269,579359,910094,1027410,226154,343967,203788,493678,340617,1005108,345268,163071,511726,856564,625093,135714,182951,684573,93967,94201,1046937,19724,822347,711674,116017,164606,871459,743040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466259 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466259 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]