SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401936 LIMIT 1 [ RunTime:0.000269s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401936 [ RunTime:0.003378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692002,335916,411193,9784,82053,557536,647323,639501,771606,188155,489030,48300,799351,1043549,767634,809624,933745,1032272,872518,836128,144110,175984,900849,536934,692488,686161,488028,264194,580789,259869,352009,99063,640244,851039,1013198,441573,952692,200750,685005,953720,973623,1029196,598690,147773,931046,1030337,180300,299009,182785,350624,541758,836820,248347,859609,907706,146047,930857,118621,540999,804460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]