SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039101 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039101 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538679,475717,819929,703623,181243,654241,639300,390754,208164,295813,392080,1029651,912087,566497,979853,373219,133908,562586,78025,489647,992043,992202,373941,882041,310397,499919,3053,346704,439125,504210,209261,781721,230105,244105,11518,598692,14533,598238,255295,745730,976039,550792,768695,616244,439647,436346,560587,691670,1038042,263904,109053,119762,194988,578729,164750,376463,896486,560203,244785,403711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]