SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041900 LIMIT 1 [ RunTime:0.003284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041900 [ RunTime:0.001969s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958573,811716,583130,1029225,423608,69674,567081,883012,853839,112264,43944,512761,824406,197979,10216,276052,945316,162509,869084,892651,1040662,53516,177217,410472,50433,880759,918708,742361,327026,754404,806423,229149,982497,585856,383213,804000,395014,950509,994435,255115,714570,609674,553338,41734,16109,709417,974319,867678,82303,615964,404105,421571,638397,652965,536255,76208,116145,211487,784293,994458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]