SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 178401 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 178401 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (811400,71451,107716,624429,609832,240191,913607,868632,1030663,377735,719319,445341,2009,385177,362683,201207,19949,598621,829179,780402,287812,639579,601401,693585,354294,373342,687775,443204,788317,698236,549301,221008,8257,905972,537698,809,344897,855747,573679,75643,829153,335106,974494,327670,68970,608104,286974,1010220,681100,533382,988050,403850,508778,559939,436840,22224,557643,194348,83649,464634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 178401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 178401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]