SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684023 LIMIT 1 [ RunTime:0.005318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684023 [ RunTime:0.008835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (189328,50168,993743,705067,312262,34569,203481,122946,226548,706812,1042858,618976,670806,658800,232745,29841,565325,813380,777001,270993,647656,270991,541205,185815,288660,167623,573401,138829,1020721,223506,1000581,251383,253158,723267,992740,164095,756237,864532,230248,661745,319587,269778,893577,507710,545710,1003623,1022522,854525,387634,1020613,872602,907527,643698,1026637,753282,362587,838734,178969,970182,457807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005917s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001308s ]