SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671343 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671343 [ RunTime:0.002681s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (645668,720534,518272,36737,255621,268132,890440,728053,752028,461404,390478,274588,843553,196342,813607,698141,933164,1016108,366570,636986,969381,991884,318979,206304,57727,754225,723739,368613,670166,886783,586157,999749,368086,479224,899588,417589,775916,101171,355065,103862,500459,716840,127795,500222,231329,313333,998018,832837,674333,238643,881230,388532,372243,563963,1045468,827534,87138,600141,879221,247863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000995s ]