SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428103 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428103 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (608798,788600,505399,369598,426850,346745,964683,687440,188649,124893,711737,809724,832809,223718,485822,603908,700745,6363,116036,956144,690121,768200,744074,441871,37044,345055,27357,245158,457673,885931,22695,478400,270288,229515,95543,416423,172418,55201,416760,353005,536810,885611,3653,1024339,134166,604503,410532,312420,968443,123345,153525,13997,561946,619583,384776,39595,306369,61978,620700,907070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]