SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434541 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434541 [ RunTime:0.005533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327094,712796,672910,1029823,777049,812548,302094,495828,40699,550179,726672,710521,613734,270300,476206,399774,614966,532895,473762,909677,56565,855665,20242,716584,856423,976933,703705,743026,909288,843940,920847,770380,222488,30493,894168,742733,629275,341418,558317,61929,184374,956541,332133,228960,154934,141269,64237,23438,588860,131126,947230,29817,586007,438287,119478,36987,454939,754020,601378,700979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]