SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046433 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046433 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (806079,102551,109644,872141,193219,463329,875881,532546,664627,86721,9391,405225,409940,280612,762471,317395,811894,639060,858324,817211,647922,89403,243377,164967,309353,267623,682062,305836,407453,24281,537798,287372,677354,36158,22641,181666,688040,756325,666625,57078,105911,53821,673405,1035451,730295,519174,787013,523273,520873,885500,686253,264494,975391,24727,463262,597211,224485,663526,177090,593099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]