SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438032 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438032 [ RunTime:0.002050s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119684,295603,980005,426497,798005,451817,232127,689122,265581,192948,581720,932947,426922,212894,48210,860475,185194,44130,182744,840162,315939,131299,661600,909605,252592,50442,493920,602858,885537,944173,535467,506826,589920,365006,410411,321814,888715,17747,537506,676417,155320,672177,213755,735371,299251,811760,898924,195742,952622,123893,786188,501666,365958,921218,772078,225594,981922,589980,705613,705851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]