SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406673 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406673 [ RunTime:0.002851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449000,540531,468067,474613,665326,102300,242758,833654,431819,18190,288924,329973,666912,172298,612815,706892,585475,479813,356264,773344,1017066,385273,625333,307630,465736,221716,220545,925794,571682,275981,948175,310601,975677,76474,512818,832488,210513,209384,1005851,282026,172445,179891,637956,840316,116759,988943,567071,904500,90380,704197,388876,39090,335173,510784,821717,861693,853942,202191,904748,989349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]