SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406288 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406288 [ RunTime:0.001767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102875,1027658,506033,803488,587085,627379,688674,484099,416360,908543,628742,147547,684902,125420,873023,956555,704355,388126,185272,411113,149663,243907,612002,23997,78270,513348,980477,491106,123214,55034,817817,96947,581780,738723,785406,731412,712630,1012140,469856,328807,722968,916614,368477,254445,417270,132582,539528,429288,191125,832188,995200,247911,874018,795520,214762,660238,715971,71893,778851,455747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406288 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406288 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001301s ]