SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001492s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046690 LIMIT 1 [ RunTime:0.001593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046690 [ RunTime:0.003397s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (985899,111343,451996,437402,166407,349694,718161,796376,1048692,854316,227404,684872,19911,270136,316696,320717,771489,723773,485570,988513,240331,493604,245180,517754,345735,912711,962832,746851,67518,926752,538275,424212,184106,958147,631510,223387,420021,845836,730522,379156,121959,990950,779968,183549,778245,993264,28344,740602,243591,89059,211036,266701,272588,471409,107315,861184,366368,962223,596588,252822) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]