SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537403 LIMIT 1 [ RunTime:0.000582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537403 [ RunTime:0.004784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226094,426547,59188,705829,625630,963141,903745,501234,1039905,269399,852,415832,436513,868092,732783,636180,701629,964370,82231,411377,479807,1040762,617254,934352,228203,721927,957263,910840,856703,34101,404356,651065,904836,129189,1041068,165999,193971,596133,1029791,566787,322446,889766,75512,1027455,725307,212516,864650,415290,1012420,133375,685369,394912,342048,821371,709325,972995,547502,894681,808708,370851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]