SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004430s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563684 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563684 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833861,578704,952767,222414,61541,334679,22041,812445,840657,1044620,24880,988327,611178,223731,448841,379126,735287,1038554,929227,568976,659944,255604,1014905,335999,875092,809893,504461,755000,1023409,750127,883191,518471,344547,490461,400221,799224,770755,40691,639472,721612,586415,769868,965178,852867,384466,304575,1048083,816006,1021240,111136,794009,946119,964298,388299,442161,672441,69696,115813,921609,853879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]