SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580568 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580568 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257271,205354,661996,227024,457590,1002901,144416,7695,284277,206934,881443,228286,655135,902486,311019,283920,390462,894056,974510,431376,227127,1034878,951508,336007,169831,93691,192018,926964,763825,750487,315533,107539,166799,239053,261386,740087,746332,113245,1045044,366755,438860,367340,633265,737170,451379,288390,976952,356705,945168,796387,177973,311525,887432,692235,414829,655261,831725,1048719,494405,894108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]