SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001728s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502592 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502592 [ RunTime:0.003542s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550748,717852,799233,583752,308224,398982,920721,943996,193955,791352,151858,623067,786984,531941,851668,421577,286123,23684,524031,412989,542427,913878,835537,418423,677821,1036301,1006592,961180,1006386,472798,517485,628461,844519,398409,744299,296676,549655,146006,709762,704975,588308,268044,225815,581164,931974,308908,569685,835183,209268,121526,692193,278245,56838,286238,720751,39510,1034612,669046,149636,930861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502592 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502592 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000805s ]