SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599617 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599617 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (384909,149607,855735,164720,417328,252012,978856,299855,733976,70762,836148,698721,688856,95194,523966,933064,767044,725563,483783,652379,48494,438410,996632,185513,408179,328526,405386,204374,225902,896504,537217,873701,763895,721488,668794,795121,801319,801449,946919,258119,115560,533987,442801,7894,762884,470879,29953,895726,82651,617935,219423,798026,663198,365153,410646,411741,631566,655072,852780,422808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001788s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599617 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599617 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]