SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017581 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017581 [ RunTime:0.013875s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396099,487876,85281,143675,275405,803874,620008,1036762,127950,504656,635800,525443,969092,618235,536730,418552,730885,344708,513469,558369,915798,802547,337681,19700,10253,118444,470850,160586,977195,701683,515177,198280,487292,495417,870347,390764,931255,163650,86294,269967,761299,63356,398733,471349,482896,33875,716988,662522,646414,253191,273206,924680,309060,723979,936743,380001,843373,177148,298572,785264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]