SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424445 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424445 [ RunTime:0.002167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835605,407518,248798,885651,845415,348280,337765,821488,353671,115361,601455,328311,408515,541095,1030107,656028,250299,770124,268294,1000821,364215,396896,360048,173087,675212,872080,506898,892974,163385,700191,1000414,672222,524437,581567,686233,130114,243909,674352,945108,511525,402343,472140,473220,275600,319124,126848,513261,837350,879300,940014,622722,551776,136042,181849,111049,1017040,958245,186576,894692,656984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]