SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286959 LIMIT 1 [ RunTime:0.000908s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286959 [ RunTime:0.003379s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030789,561764,722208,252257,7478,722245,712303,617812,237519,175417,157440,1006131,482757,384473,157150,898841,250170,196131,690438,498454,161054,502862,801829,779859,44081,726391,672557,109986,255941,183070,487234,705470,1048537,491970,500443,955644,504240,396083,317998,356084,846793,674278,45059,759792,905665,228258,57451,599307,2366,1026304,923739,107027,691021,904458,646409,604526,880040,801293,651631,1002290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]