SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536650 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536650 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629738,337061,333063,939375,950898,32791,319686,496642,963457,359066,762250,456025,789906,981217,70793,620096,629658,250584,548153,965533,57511,273297,730965,240348,515495,438803,375727,859491,507770,878337,585535,945336,56434,383613,1029655,662029,160102,831082,942649,889645,723336,941258,1040356,57415,929491,805878,231309,308736,141694,157039,340122,83809,1031190,370234,115229,791667,402951,949701,351930,928140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001187s ]