SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 178043 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 178043 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118110,1030154,538102,742810,892913,3258,420486,363082,490714,248684,488446,123479,384374,106218,1017412,251158,623959,969740,63220,336042,269768,12560,153360,653341,817837,122050,195926,889440,916250,88608,871709,470616,979256,153162,531431,124368,930646,19011,713253,583182,326547,740021,232456,667811,577778,947233,152329,11496,286533,334516,974009,772735,295503,950834,644322,925621,259248,705848,714852,440273) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 178043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 178043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]