SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800504 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800504 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88911,171073,536049,752610,42300,19828,322759,146551,30311,692705,233552,356747,877029,271619,236507,297756,161171,1048415,632828,1015109,1033406,184188,717768,938178,561800,50176,808970,180014,985636,884113,414926,596442,17004,662848,293611,673864,275847,139565,895245,1029162,837241,448480,279056,731012,849058,466697,636958,923045,213144,308312,973252,997618,311250,968510,966732,518089,530497,15877,264880,96417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]