SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409117 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409117 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438750,387439,11816,130509,663704,704296,167826,165750,755962,496415,408914,652543,96066,48306,856790,292291,349652,287146,217693,933795,437724,948698,231366,890549,135613,341968,805476,483439,383654,819172,1016488,519012,849026,674085,501597,479364,305783,406534,146968,238925,893540,588734,515227,940351,733775,907465,831754,473849,288433,595550,925755,738484,753531,517744,496385,214779,349295,231517,331244,401589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]