SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012979 LIMIT 1 [ RunTime:0.000589s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012979 [ RunTime:0.002763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37584,703486,817208,52118,302378,486929,239116,622988,391384,315074,187103,700044,10614,260050,403721,366889,238088,490393,499814,194694,243483,83409,252169,307648,397031,915513,562225,184692,71178,521610,523726,268233,663296,793430,810578,179526,202824,365559,567232,993604,931509,411894,850157,547695,168468,56042,115233,955107,745561,761277,998738,482084,298052,428153,664517,410663,300585,901770,149081,840836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012979 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012979 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]