SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10501 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10501 [ RunTime:0.002047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452316,106432,716411,723194,344861,855097,228916,193031,274633,1019259,263339,663269,608256,479049,962614,19237,564894,318465,891683,6150,331707,919208,453231,90799,1007997,266680,950318,173354,275784,645739,109875,295612,20529,121830,448151,326352,254752,184242,985863,558199,679985,904969,435915,560355,650063,1005732,242377,98149,747527,299151,593089,20513,449718,723339,617449,245227,705041,994510,785245,729372) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000683s ]