SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401182 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401182 [ RunTime:0.002296s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9420,758466,317638,858976,673368,286453,38067,1028296,512431,365245,730035,339928,287924,941502,995015,874580,520061,260481,40350,950091,975580,702011,72037,1040167,90884,284080,652827,588656,402741,548090,144693,163663,808403,557182,999723,903914,818929,561653,194523,54809,303730,273451,552456,883774,911412,245181,378804,548205,939641,989075,567911,285931,551197,577724,812370,946265,559947,894300,126316,38055) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]