SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 980940 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 980940 [ RunTime:0.001385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262935,431989,685663,595252,13894,882129,681583,832225,942907,418368,472792,237999,193387,926536,759792,459483,568347,713309,234671,206355,20652,666720,993214,108652,398353,1044761,145043,676671,748181,443140,746763,859172,287596,571330,1032672,954119,722904,129017,709511,128158,101257,867197,663582,90436,464562,696324,519795,580744,25680,170524,62353,484242,96937,996466,842229,302371,591438,570209,486818,810538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 980940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 980940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]