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` = 1000914 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000914 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529787,287469,322820,752170,308814,960396,488234,597174,811350,420097,686603,727188,962246,295581,688304,696695,420240,577276,851086,466689,1002404,143682,480473,643393,255369,759111,112022,912365,259889,491372,236531,360952,746244,248737,258285,478114,59123,622817,649334,862671,574478,1036643,298958,747073,402927,205619,2846,902714,275040,559176,40930,755101,900409,231984,571370,504586,964591,655389,710362,597938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]