SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005781 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005781 [ RunTime:0.002720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171723,662925,171904,577080,802615,679880,150282,620224,751575,46769,180553,566750,71309,529286,717363,1005745,1008721,55666,742208,342689,508280,323450,893023,1000325,443550,432940,658591,32241,69475,547053,978863,1002812,916727,234650,236369,43923,291890,753991,873477,394793,440409,357024,224629,849802,785846,312840,18719,340542,1046438,462335,774765,520345,253058,106578,61834,130727,85010,467829,804066,440369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]